SQLSmts: Using Dynaset SQL Statements From a List Box in VB 3.0

The sample SQL_PUB.MAK project contains the file SQL_PUB.FRM. 

The idea of the sample is to demonstrate how to use the CreateDynaset method
and a Dynaset object variable with a variable that you have the user select from a 
List box. The result of the search will bring up the entire record to be 
read or updated. This sample uses an SQL statement with a string variable in
the Where clause.

You first want to select an entry in the List1 list box control by
clicking on a item contained in the list box. Next you will see all of the
text boxes become filled with the other fields that pertain to the record
that you selected.  Then you can either start editing the fields of the
record that you desire to change or select the 'Push to make ReadOnly'
command button to prevent changes from being made. There are also some
additional command buttons, one is for setting the Read/Write options on
the text boxes, another for saving changes made to the data and the last one
for not saving changes to the data.

You can continue the same sequence with different selections from the List1
list box.